package com.igfd.tanmao.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface UniqueCodeProductMapper {

    @Select("select count(*) from products_unique_code_info as u " +
            "left join product_batch_info_detail as d on d.id = u.batch_id where d.spu = #{spu} and u.is_sell = 'N' and u.state != 4")
    int findCurrentSizeCount(@Param("spu") String spu);
}
